package cn.hengzhu.main_manager.repository.domain;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ManageCaseExample {
    /**
     * @mbg.generated
     */
    protected String orderByClause;

    /**
     * @mbg.generated
     */
    protected boolean distinct;

    /**
     * @mbg.generated
     */
    protected List<Criteria> oredCriteria;

    /**
     * @mbg.generated
     */
    public ManageCaseExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * @mbg.generated
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * @mbg.generated
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * @mbg.generated
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * @mbg.generated
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * @mbg.generated
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * @mbg.generated
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * @mbg.generated
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * @mbg.generated
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * @mbg.generated
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();

        return criteria;
    }

    /**
     * @mbg.generated
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * 根据此类会生成不同的sql
     *
     * @mbg.generated
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCaseNoIsNull() {
            addCriterion("CASE_NO is null");
            return (Criteria) this;
        }

        public Criteria andCaseNoIsNotNull() {
            addCriterion("CASE_NO is not null");
            return (Criteria) this;
        }

        public Criteria andCaseNoEqualTo(String value) {
            addCriterion("CASE_NO =", value, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoNotEqualTo(String value) {
            addCriterion("CASE_NO <>", value, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoGreaterThan(String value) {
            addCriterion("CASE_NO >", value, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoGreaterThanOrEqualTo(String value) {
            addCriterion("CASE_NO >=", value, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoLessThan(String value) {
            addCriterion("CASE_NO <", value, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoLessThanOrEqualTo(String value) {
            addCriterion("CASE_NO <=", value, "caseNo");
            return (Criteria) this;
        }

        /**
         * 模糊匹配
         *
         * @param value
         * @return
         */
        public Criteria andCaseNoLike(String value) {
            addCriterion("CASE_NO like", value, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoNotLike(String value) {
            addCriterion("CASE_NO not like", value, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoIn(List<String> values) {
            addCriterion("CASE_NO in", values, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoNotIn(List<String> values) {
            addCriterion("CASE_NO not in", values, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoBetween(String value1, String value2) {
            addCriterion("CASE_NO between", value1, value2, "caseNo");
            return (Criteria) this;
        }

        public Criteria andCaseNoNotBetween(String value1, String value2) {
            addCriterion("CASE_NO not between", value1, value2, "caseNo");
            return (Criteria) this;
        }

        public Criteria andBoxSumIsNull() {
            addCriterion("BOX_SUM is null");
            return (Criteria) this;
        }

        public Criteria andBoxSumIsNotNull() {
            addCriterion("BOX_SUM is not null");
            return (Criteria) this;
        }

        public Criteria andBoxSumEqualTo(Integer value) {
            addCriterion("BOX_SUM =", value, "boxSum");
            return (Criteria) this;
        }

        public Criteria andBoxSumNotEqualTo(Integer value) {
            addCriterion("BOX_SUM <>", value, "boxSum");
            return (Criteria) this;
        }

        public Criteria andBoxSumGreaterThan(Integer value) {
            addCriterion("BOX_SUM >", value, "boxSum");
            return (Criteria) this;
        }

        public Criteria andBoxSumGreaterThanOrEqualTo(Integer value) {
            addCriterion("BOX_SUM >=", value, "boxSum");
            return (Criteria) this;
        }

        public Criteria andBoxSumLessThan(Integer value) {
            addCriterion("BOX_SUM <", value, "boxSum");
            return (Criteria) this;
        }

        public Criteria andBoxSumLessThanOrEqualTo(Integer value) {
            addCriterion("BOX_SUM <=", value, "boxSum");
            return (Criteria) this;
        }

        public Criteria andBoxSumIn(List<Integer> values) {
            addCriterion("BOX_SUM in", values, "boxSum");
            return (Criteria) this;
        }

        public Criteria andBoxSumNotIn(List<Integer> values) {
            addCriterion("BOX_SUM not in", values, "boxSum");
            return (Criteria) this;
        }

        public Criteria andBoxSumBetween(Integer value1, Integer value2) {
            addCriterion("BOX_SUM between", value1, value2, "boxSum");
            return (Criteria) this;
        }

        public Criteria andBoxSumNotBetween(Integer value1, Integer value2) {
            addCriterion("BOX_SUM not between", value1, value2, "boxSum");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andPlaceIsNull() {
            addCriterion("PLACE is null");
            return (Criteria) this;
        }

        public Criteria andPlaceIsNotNull() {
            addCriterion("PLACE is not null");
            return (Criteria) this;
        }

        public Criteria andPlaceEqualTo(String value) {
            addCriterion("PLACE =", value, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceNotEqualTo(String value) {
            addCriterion("PLACE <>", value, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceGreaterThan(String value) {
            addCriterion("PLACE >", value, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceGreaterThanOrEqualTo(String value) {
            addCriterion("PLACE >=", value, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceLessThan(String value) {
            addCriterion("PLACE <", value, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceLessThanOrEqualTo(String value) {
            addCriterion("PLACE <=", value, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceLike(String value) {
            addCriterion("PLACE like", value, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceNotLike(String value) {
            addCriterion("PLACE not like", value, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceIn(List<String> values) {
            addCriterion("PLACE in", values, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceNotIn(List<String> values) {
            addCriterion("PLACE not in", values, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceBetween(String value1, String value2) {
            addCriterion("PLACE between", value1, value2, "place");
            return (Criteria) this;
        }

        public Criteria andPlaceNotBetween(String value1, String value2) {
            addCriterion("PLACE not between", value1, value2, "place");
            return (Criteria) this;
        }

        public Criteria andDesIsNull() {
            addCriterion("DES is null");
            return (Criteria) this;
        }

        public Criteria andDesIsNotNull() {
            addCriterion("DES is not null");
            return (Criteria) this;
        }

        public Criteria andDesEqualTo(String value) {
            addCriterion("DES =", value, "des");
            return (Criteria) this;
        }

        public Criteria andDesNotEqualTo(String value) {
            addCriterion("DES <>", value, "des");
            return (Criteria) this;
        }

        public Criteria andDesGreaterThan(String value) {
            addCriterion("DES >", value, "des");
            return (Criteria) this;
        }

        public Criteria andDesGreaterThanOrEqualTo(String value) {
            addCriterion("DES >=", value, "des");
            return (Criteria) this;
        }

        public Criteria andDesLessThan(String value) {
            addCriterion("DES <", value, "des");
            return (Criteria) this;
        }

        public Criteria andDesLessThanOrEqualTo(String value) {
            addCriterion("DES <=", value, "des");
            return (Criteria) this;
        }

        public Criteria andDesLike(String value) {
            addCriterion("DES like", value, "des");
            return (Criteria) this;
        }

        public Criteria andDesNotLike(String value) {
            addCriterion("DES not like", value, "des");
            return (Criteria) this;
        }

        public Criteria andDesIn(List<String> values) {
            addCriterion("DES in", values, "des");
            return (Criteria) this;
        }

        public Criteria andDesNotIn(List<String> values) {
            addCriterion("DES not in", values, "des");
            return (Criteria) this;
        }

        public Criteria andDesBetween(String value1, String value2) {
            addCriterion("DES between", value1, value2, "des");
            return (Criteria) this;
        }

        public Criteria andDesNotBetween(String value1, String value2) {
            addCriterion("DES not between", value1, value2, "des");
            return (Criteria) this;
        }

        public Criteria andIsOnlineIsNull() {
            addCriterion("IS_ONLINE is null");
            return (Criteria) this;
        }

        public Criteria andIsOnlineIsNotNull() {
            addCriterion("IS_ONLINE is not null");
            return (Criteria) this;
        }

        public Criteria andIsOnlineEqualTo(Byte value) {
            addCriterion("IS_ONLINE =", value, "isOnline");
            return (Criteria) this;
        }

        public Criteria andIsOnlineNotEqualTo(Byte value) {
            addCriterion("IS_ONLINE <>", value, "isOnline");
            return (Criteria) this;
        }

        public Criteria andIsOnlineGreaterThan(Byte value) {
            addCriterion("IS_ONLINE >", value, "isOnline");
            return (Criteria) this;
        }

        public Criteria andIsOnlineGreaterThanOrEqualTo(Byte value) {
            addCriterion("IS_ONLINE >=", value, "isOnline");
            return (Criteria) this;
        }

        public Criteria andIsOnlineLessThan(Byte value) {
            addCriterion("IS_ONLINE <", value, "isOnline");
            return (Criteria) this;
        }

        public Criteria andIsOnlineLessThanOrEqualTo(Byte value) {
            addCriterion("IS_ONLINE <=", value, "isOnline");
            return (Criteria) this;
        }

        public Criteria andIsOnlineIn(List<Byte> values) {
            addCriterion("IS_ONLINE in", values, "isOnline");
            return (Criteria) this;
        }

        public Criteria andIsOnlineNotIn(List<Byte> values) {
            addCriterion("IS_ONLINE not in", values, "isOnline");
            return (Criteria) this;
        }

        public Criteria andIsOnlineBetween(Byte value1, Byte value2) {
            addCriterion("IS_ONLINE between", value1, value2, "isOnline");
            return (Criteria) this;
        }

        public Criteria andIsOnlineNotBetween(Byte value1, Byte value2) {
            addCriterion("IS_ONLINE not between", value1, value2, "isOnline");
            return (Criteria) this;
        }

        public Criteria andCompIdIsNull() {
            addCriterion("COMP_ID is null");
            return (Criteria) this;
        }

        public Criteria andCompIdIsNotNull() {
            addCriterion("COMP_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCompIdEqualTo(Integer value) {
            // 第三个参数实质没什么作用 只是在发生异常的时候的一个异常信息
            addCriterion("COMP_ID =", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdNotEqualTo(Integer value) {
            addCriterion("COMP_ID <>", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdGreaterThan(Integer value) {
            addCriterion("COMP_ID >", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("COMP_ID >=", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdLessThan(Integer value) {
            addCriterion("COMP_ID <", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdLessThanOrEqualTo(Integer value) {
            addCriterion("COMP_ID <=", value, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdIn(List<Integer> values) {
            addCriterion("COMP_ID in", values, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdNotIn(List<Integer> values) {
            addCriterion("COMP_ID not in", values, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdBetween(Integer value1, Integer value2) {
            addCriterion("COMP_ID between", value1, value2, "compId");
            return (Criteria) this;
        }

        public Criteria andCompIdNotBetween(Integer value1, Integer value2) {
            addCriterion("COMP_ID not between", value1, value2, "compId");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyIsNull() {
            addCriterion("CASE_NO_BUY is null");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyIsNotNull() {
            addCriterion("CASE_NO_BUY is not null");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyEqualTo(String value) {
            addCriterion("CASE_NO_BUY =", value, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyNotEqualTo(String value) {
            addCriterion("CASE_NO_BUY <>", value, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyGreaterThan(String value) {
            addCriterion("CASE_NO_BUY >", value, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyGreaterThanOrEqualTo(String value) {
            addCriterion("CASE_NO_BUY >=", value, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyLessThan(String value) {
            addCriterion("CASE_NO_BUY <", value, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyLessThanOrEqualTo(String value) {
            addCriterion("CASE_NO_BUY <=", value, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyLike(String value) {
            addCriterion("CASE_NO_BUY like", value, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyNotLike(String value) {
            addCriterion("CASE_NO_BUY not like", value, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyIn(List<String> values) {
            addCriterion("CASE_NO_BUY in", values, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyNotIn(List<String> values) {
            addCriterion("CASE_NO_BUY not in", values, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyBetween(String value1, String value2) {
            addCriterion("CASE_NO_BUY between", value1, value2, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCaseNoBuyNotBetween(String value1, String value2) {
            addCriterion("CASE_NO_BUY not between", value1, value2, "caseNoBuy");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andLatitudeIsNull() {
            addCriterion("LATITUDE is null");
            return (Criteria) this;
        }

        public Criteria andLatitudeIsNotNull() {
            addCriterion("LATITUDE is not null");
            return (Criteria) this;
        }

        public Criteria andLatitudeEqualTo(String value) {
            addCriterion("LATITUDE =", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotEqualTo(String value) {
            addCriterion("LATITUDE <>", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeGreaterThan(String value) {
            addCriterion("LATITUDE >", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeGreaterThanOrEqualTo(String value) {
            addCriterion("LATITUDE >=", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeLessThan(String value) {
            addCriterion("LATITUDE <", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeLessThanOrEqualTo(String value) {
            addCriterion("LATITUDE <=", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeLike(String value) {
            addCriterion("LATITUDE like", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotLike(String value) {
            addCriterion("LATITUDE not like", value, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeIn(List<String> values) {
            addCriterion("LATITUDE in", values, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotIn(List<String> values) {
            addCriterion("LATITUDE not in", values, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeBetween(String value1, String value2) {
            addCriterion("LATITUDE between", value1, value2, "latitude");
            return (Criteria) this;
        }

        public Criteria andLatitudeNotBetween(String value1, String value2) {
            addCriterion("LATITUDE not between", value1, value2, "latitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeIsNull() {
            addCriterion("LONGITUDE is null");
            return (Criteria) this;
        }

        public Criteria andLongitudeIsNotNull() {
            addCriterion("LONGITUDE is not null");
            return (Criteria) this;
        }

        public Criteria andLongitudeEqualTo(String value) {
            addCriterion("LONGITUDE =", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeNotEqualTo(String value) {
            addCriterion("LONGITUDE <>", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeGreaterThan(String value) {
            addCriterion("LONGITUDE >", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeGreaterThanOrEqualTo(String value) {
            addCriterion("LONGITUDE >=", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeLessThan(String value) {
            addCriterion("LONGITUDE <", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeLessThanOrEqualTo(String value) {
            addCriterion("LONGITUDE <=", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeLike(String value) {
            addCriterion("LONGITUDE like", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeNotLike(String value) {
            addCriterion("LONGITUDE not like", value, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeIn(List<String> values) {
            addCriterion("LONGITUDE in", values, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeNotIn(List<String> values) {
            addCriterion("LONGITUDE not in", values, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeBetween(String value1, String value2) {
            addCriterion("LONGITUDE between", value1, value2, "longitude");
            return (Criteria) this;
        }

        public Criteria andLongitudeNotBetween(String value1, String value2) {
            addCriterion("LONGITUDE not between", value1, value2, "longitude");
            return (Criteria) this;
        }

        public Criteria andTypeIdIsNull() {
            addCriterion("TYPE_ID is null");
            return (Criteria) this;
        }

        public Criteria andTypeIdIsNotNull() {
            addCriterion("TYPE_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTypeIdEqualTo(Integer value) {
            addCriterion("TYPE_ID =", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotEqualTo(Integer value) {
            addCriterion("TYPE_ID <>", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdGreaterThan(Integer value) {
            addCriterion("TYPE_ID >", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("TYPE_ID >=", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdLessThan(Integer value) {
            addCriterion("TYPE_ID <", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("TYPE_ID <=", value, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdIn(List<Integer> values) {
            addCriterion("TYPE_ID in", values, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotIn(List<Integer> values) {
            addCriterion("TYPE_ID not in", values, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("TYPE_ID between", value1, value2, "typeId");
            return (Criteria) this;
        }

        public Criteria andTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("TYPE_ID not between", value1, value2, "typeId");
            return (Criteria) this;
        }

        public Criteria andUseTypeIsNull() {
            addCriterion("USE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andUseTypeIsNotNull() {
            addCriterion("USE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andUseTypeEqualTo(Byte value) {
            addCriterion("USE_TYPE =", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeNotEqualTo(Byte value) {
            addCriterion("USE_TYPE <>", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeGreaterThan(Byte value) {
            addCriterion("USE_TYPE >", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("USE_TYPE >=", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeLessThan(Byte value) {
            addCriterion("USE_TYPE <", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeLessThanOrEqualTo(Byte value) {
            addCriterion("USE_TYPE <=", value, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeIn(List<Byte> values) {
            addCriterion("USE_TYPE in", values, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeNotIn(List<Byte> values) {
            addCriterion("USE_TYPE not in", values, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeBetween(Byte value1, Byte value2) {
            addCriterion("USE_TYPE between", value1, value2, "useType");
            return (Criteria) this;
        }

        public Criteria andUseTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("USE_TYPE not between", value1, value2, "useType");
            return (Criteria) this;
        }

        public Criteria andIsSizeIsNull() {
            addCriterion("IS_SIZE is null");
            return (Criteria) this;
        }

        public Criteria andIsSizeIsNotNull() {
            addCriterion("IS_SIZE is not null");
            return (Criteria) this;
        }

        public Criteria andIsSizeEqualTo(Byte value) {
            addCriterion("IS_SIZE =", value, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsSizeNotEqualTo(Byte value) {
            addCriterion("IS_SIZE <>", value, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsSizeGreaterThan(Byte value) {
            addCriterion("IS_SIZE >", value, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsSizeGreaterThanOrEqualTo(Byte value) {
            addCriterion("IS_SIZE >=", value, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsSizeLessThan(Byte value) {
            addCriterion("IS_SIZE <", value, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsSizeLessThanOrEqualTo(Byte value) {
            addCriterion("IS_SIZE <=", value, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsSizeIn(List<Byte> values) {
            addCriterion("IS_SIZE in", values, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsSizeNotIn(List<Byte> values) {
            addCriterion("IS_SIZE not in", values, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsSizeBetween(Byte value1, Byte value2) {
            addCriterion("IS_SIZE between", value1, value2, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsSizeNotBetween(Byte value1, Byte value2) {
            addCriterion("IS_SIZE not between", value1, value2, "isSize");
            return (Criteria) this;
        }

        public Criteria andIsNormalIsNull() {
            addCriterion("IS_NORMAL is null");
            return (Criteria) this;
        }

        public Criteria andIsNormalIsNotNull() {
            addCriterion("IS_NORMAL is not null");
            return (Criteria) this;
        }

        public Criteria andIsNormalEqualTo(Byte value) {
            addCriterion("IS_NORMAL =", value, "isNormal");
            return (Criteria) this;
        }

        public Criteria andIsNormalNotEqualTo(Byte value) {
            addCriterion("IS_NORMAL <>", value, "isNormal");
            return (Criteria) this;
        }

        public Criteria andIsNormalGreaterThan(Byte value) {
            addCriterion("IS_NORMAL >", value, "isNormal");
            return (Criteria) this;
        }

        public Criteria andIsNormalGreaterThanOrEqualTo(Byte value) {
            addCriterion("IS_NORMAL >=", value, "isNormal");
            return (Criteria) this;
        }

        public Criteria andIsNormalLessThan(Byte value) {
            addCriterion("IS_NORMAL <", value, "isNormal");
            return (Criteria) this;
        }

        public Criteria andIsNormalLessThanOrEqualTo(Byte value) {
            addCriterion("IS_NORMAL <=", value, "isNormal");
            return (Criteria) this;
        }

        public Criteria andIsNormalIn(List<Byte> values) {
            addCriterion("IS_NORMAL in", values, "isNormal");
            return (Criteria) this;
        }

        public Criteria andIsNormalNotIn(List<Byte> values) {
            addCriterion("IS_NORMAL not in", values, "isNormal");
            return (Criteria) this;
        }

        public Criteria andIsNormalBetween(Byte value1, Byte value2) {
            addCriterion("IS_NORMAL between", value1, value2, "isNormal");
            return (Criteria) this;
        }

        public Criteria andIsNormalNotBetween(Byte value1, Byte value2) {
            addCriterion("IS_NORMAL not between", value1, value2, "isNormal");
            return (Criteria) this;
        }

        public Criteria andClearHourIsNull() {
            addCriterion("CLEAR_HOUR is null");
            return (Criteria) this;
        }

        public Criteria andClearHourIsNotNull() {
            addCriterion("CLEAR_HOUR is not null");
            return (Criteria) this;
        }

        public Criteria andClearHourEqualTo(Integer value) {
            addCriterion("CLEAR_HOUR =", value, "clearHour");
            return (Criteria) this;
        }

        public Criteria andClearHourNotEqualTo(Integer value) {
            addCriterion("CLEAR_HOUR <>", value, "clearHour");
            return (Criteria) this;
        }

        public Criteria andClearHourGreaterThan(Integer value) {
            addCriterion("CLEAR_HOUR >", value, "clearHour");
            return (Criteria) this;
        }

        public Criteria andClearHourGreaterThanOrEqualTo(Integer value) {
            addCriterion("CLEAR_HOUR >=", value, "clearHour");
            return (Criteria) this;
        }

        public Criteria andClearHourLessThan(Integer value) {
            addCriterion("CLEAR_HOUR <", value, "clearHour");
            return (Criteria) this;
        }

        public Criteria andClearHourLessThanOrEqualTo(Integer value) {
            addCriterion("CLEAR_HOUR <=", value, "clearHour");
            return (Criteria) this;
        }

        public Criteria andClearHourIn(List<Integer> values) {
            addCriterion("CLEAR_HOUR in", values, "clearHour");
            return (Criteria) this;
        }

        public Criteria andClearHourNotIn(List<Integer> values) {
            addCriterion("CLEAR_HOUR not in", values, "clearHour");
            return (Criteria) this;
        }

        public Criteria andClearHourBetween(Integer value1, Integer value2) {
            addCriterion("CLEAR_HOUR between", value1, value2, "clearHour");
            return (Criteria) this;
        }

        public Criteria andClearHourNotBetween(Integer value1, Integer value2) {
            addCriterion("CLEAR_HOUR not between", value1, value2, "clearHour");
            return (Criteria) this;
        }

        public Criteria andQrUrlIsNull() {
            addCriterion("QR_URL is null");
            return (Criteria) this;
        }

        public Criteria andQrUrlIsNotNull() {
            addCriterion("QR_URL is not null");
            return (Criteria) this;
        }

        public Criteria andQrUrlEqualTo(String value) {
            addCriterion("QR_URL =", value, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlNotEqualTo(String value) {
            addCriterion("QR_URL <>", value, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlGreaterThan(String value) {
            addCriterion("QR_URL >", value, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlGreaterThanOrEqualTo(String value) {
            addCriterion("QR_URL >=", value, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlLessThan(String value) {
            addCriterion("QR_URL <", value, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlLessThanOrEqualTo(String value) {
            addCriterion("QR_URL <=", value, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlLike(String value) {
            addCriterion("QR_URL like", value, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlNotLike(String value) {
            addCriterion("QR_URL not like", value, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlIn(List<String> values) {
            addCriterion("QR_URL in", values, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlNotIn(List<String> values) {
            addCriterion("QR_URL not in", values, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlBetween(String value1, String value2) {
            addCriterion("QR_URL between", value1, value2, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andQrUrlNotBetween(String value1, String value2) {
            addCriterion("QR_URL not between", value1, value2, "qrUrl");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityIsNull() {
            addCriterion("IS_BOX_OFFLINE_NOTIFY is null");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityIsNotNull() {
            addCriterion("IS_BOX_OFFLINE_NOTIFY is not null");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityEqualTo(Byte value) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY =", value, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityNotEqualTo(Byte value) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY <>", value, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityGreaterThan(Byte value) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY >", value, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityGreaterThanOrEqualTo(Byte value) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY >=", value, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityLessThan(Byte value) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY <", value, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityLessThanOrEqualTo(Byte value) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY <=", value, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityIn(List<Byte> values) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY in", values, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityNotIn(List<Byte> values) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY not in", values, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityBetween(Byte value1, Byte value2) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY between", value1, value2, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andIsBoxOfflineNotityNotBetween(Byte value1, Byte value2) {
            addCriterion("IS_BOX_OFFLINE_NOTIFY not between", value1, value2, "isBoxOfflineNotity");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberIsNull() {
            addCriterion("BIND_PHONE_NUMBER is null");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberIsNotNull() {
            addCriterion("BIND_PHONE_NUMBER is not null");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberEqualTo(Byte value) {
            addCriterion("BIND_PHONE_NUMBER =", value, "bindPhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberNotEqualTo(Byte value) {
            addCriterion("BIND_PHONE_NUMBER <>", value, "bindPhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberGreaterThan(Byte value) {
            addCriterion("BIND_PHONE_NUMBER >", value, "bindPhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberGreaterThanOrEqualTo(Byte value) {
            addCriterion("BIND_PHONE_NUMBER >=", value, "bindPhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberLessThan(Byte value) {
            addCriterion("BIND_PHONE_NUMBER <", value, "bindPhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberLessThanOrEqualTo(Byte value) {
            addCriterion("BIND_PHONE_NUMBER <=", value, "bindPhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberIn(List<Byte> values) {
            addCriterion("BIND_PHONE_NUMBER in", values, "bindPhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberNotIn(List<Byte> values) {
            addCriterion("BIND_PHONE_NUMBER not in", values, "bindPhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberBetween(Byte value1, Byte value2) {
            addCriterion("BIND_PHONE_NUMBER between", value1, value2, "bindPhoneNumber");
            return (Criteria) this;
        }

        public Criteria andBindPhoneNumberNotBetween(Byte value1, Byte value2) {
            addCriterion("BIND_PHONE_NUMBER not between", value1, value2, "bindPhoneNumber");
            return (Criteria) this;
        }
    }

    /**
     * @mbg.generated do_not_delete_during_merge
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }

    }

    /**
     * @mbg.generated
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        //标识符 标识当前value是单值
        private boolean singleValue;
        //标识当前value是list
        private boolean listValue;

        private boolean betweenValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}